SUPPORT

Select Your Region

Visit the Cary, NC, US corporate headquarters site

Americas

Europe

Middle East & Africa

Asia Pacific

View our worldwide contacts list for help finding your region

Americas

Europe

Middle East & Africa

Asia Pacific

Sign In

Get access to My SAS, trials, communities and more.

Sign Out

Get access to My SAS, trials, communities and more.

SAS Sites

sas.com
Support
Blogs
Communities
Developer
Curiosity
Videos

Documentation

Learn
Brand
PartnerNet
Merchandise
SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 51217: Optimization is slow because there is too much competitor price data

DetailsAboutRate It

SAS® Revenue Optimization might perform slowly when there is a large amount of historical competitor price data in the DI_DM.COMP_PRICE_FACT table.

This issue occurs because there is no purge program for DI_DM.COMP_PRICE_FACT.

Contact Technical Support for assistance in purging historical competitor price data.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Regular Price OptimizationMicrosoft Windows Server 2003 Datacenter Edition4.2_M19.2 TS2M3
Microsoft Windows Server 2003 Enterprise Edition4.2_M19.2 TS2M3
Microsoft Windows Server 2003 Standard Edition4.2_M19.2 TS2M3
Microsoft Windows Server 2003 for x644.2_M19.2 TS2M3
Microsoft® Windows® for x645.25.49.3 TS1M19.4 TS1M3
64-bit Enabled AIX4.2_M19.2 TS2M3
Microsoft Windows Server 2008 for x644.2_M19.2 TS2M3
Microsoft Windows Server 20084.2_M19.2 TS2M3
Linux for x645.25.49.3 TS1M19.4 TS1M3
SAS SystemSAS Promotion OptimizationMicrosoft Windows Server 2003 Datacenter Edition4.2_M19.2 TS2M3
Microsoft Windows Server 2003 Enterprise Edition4.2_M19.2 TS2M3
Microsoft Windows Server 2003 Standard Edition4.2_M19.2 TS2M3
Microsoft Windows Server 2003 for x644.2_M19.2 TS2M3
Microsoft Windows Server 20084.2_M19.2 TS2M3
Microsoft Windows Server 2008 for x644.2_M19.2 TS2M3
64-bit Enabled AIX4.2_M19.2 TS2M3
Linux for x645.25.49.3 TS1M19.4 TS1M3
Microsoft® Windows® for x645.25.49.3 TS1M19.4 TS1M3
SAS SystemSAS High-Performance Markdown OptimizationMicrosoft® Windows® for x644.3_M29.2 TS2M3
Linux for x644.3_M29.2 TS2M3
SAS SystemSAS Markdown OptimizationMicrosoft® Windows® for x645.25.49.3 TS1M19.4 TS1M3
Linux for x645.25.49.3 TS1M19.4 TS1M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.